BEGIN;
CREATE VIEW invoice_details as (SELECT gsp_id,nos_invoice_date||' / gsp' as invoice_no from gsp_item_details where nos_invoice_date<>'') Union (Select commercial_id,invoice_no||'/'||invoice_date||' / coc' from certificate_of_origin_commercial where invoice_no<>'');
COMMIT;